import xlrd


class DeleteCardData:
    book = xlrd.open_workbook(filename='D:/工作/2023年6月/test_data.xlsx')

    st = book.sheet_by_name('deletecard_success_data')

    row_num = st.nrows

    deletecard_success_data = []

    for i in range(1, row_num):
        deletecard_success_data.append(st.row_values(i))

    st = book.sheet_by_name('deletecard_cancel_data')

    row_num = st.nrows

    deletecard_cancel_data = []

    for i in range(1, row_num):
        deletecard_cancel_data.append(st.row_values(i))
